Chip 2004 December

home *** CD-ROM | disk | FTP | other *** search

/ Chip 2004 December / 2004-12 CHIP.iso / Dom i biuro / Crimson Editor 3.70 / cedt370r.exe / spec / tsql.key < prev next >

Wrap

INI File | 2004-05-28 | 39KB | 2,023 lines

[-COMMENT-:GLOBAL] # T/SQL LANGUAGE KEYWORDS FILE FOR CRIMSON EDITOR # SQL Server 2000 # 2004.05.04 (John Hales) - First Release # 2004.05.29 (Stephen Mills) - Second Release - major changes in all sections # To go to the section double click it then hit F3. # KEYWORDS0 = Default Databases # KEYWORDS1 = Roles, default users, default logins # KEYWORDS2 = Data Types # KEYWORDS3 = Global Variables # KEYWORDS4 = Expressions and Comparisons # KEYWORDS5 = Built-In Functions # KEYWORDS6 = System Tables & Views # KEYWORDS7 = System Stored Procedures, Extended Stored Procedure and Functions # KEYWORDS8 = Other Reserved Keywords # KEYWORDS9 = Unused [KEYWORDS0:GLOBAL] # Default Databases master model msdb Northwind pubs tempdb [KEYWORDS1:GLOBAL] # Roles, default users, default logins BUILTIN\Administrators bulkadmin db_accessadmin db_backupoperator db_datareader db_datawriter db_ddladmin db_denydatareader db_denydatawriter db_owner db_securityadmin dbcreator dbo diskadmin guest INFORMATION_SCHEMA processadmin public sa securityadmin serveradmin setupadmin sysadmin system_function_schema [KEYWORDS2:GLOBAL] # Data Types BIGINT BINARY BIT CHAR CHARACTER DATETIME DEC DECIMAL FLOAT IMAGE INT INTEGER MONEY NCHAR NTEXT NUMERIC NVARCHAR REAL ROWVERSION SMALLDATETIME SMALLINT SMALLMONEY SQL_VARIANT SYSNAME TEXT TIMESTAMP TINYINT UNIQUEIDENTIFIER VARBINARY VARCHAR [KEYWORDS3:GLOBAL] # Global Variables # Color set by variable color not by Keywords3 color @@CONNECTIONS @@CPU_BUSY @@CURSOR_ROWS @@DATEFIRST @@DBTS @@ERROR @@FETCH_STATUS @@IDENTITY @@IDLE @@IO_BUSY @@LANGID @@LANGUAGE @@LOCK_TIMEOUT @@MAX_CONNECTIONS @@MAX_PRECISION @@NESTLEVEL @@OPTIONS @@PACK_RECEIVED @@PACK_SENT @@PACKET_ERRORS @@PROCID @@REMSERVER @@ROWCOUNT @@SERVERNAME @@SERVICENAME @@SPID @@TEXTSIZE @@TIMETICKS @@TOTAL_ERRORS @@TOTAL_READ @@TOTAL_WRITE @@TRANCOUNT @@VERSION [KEYWORDS4:GLOBAL] # Expressions and Comparisons !< != !> % & * + - / < <= <> = > >= ^ ALL AND ANY BETWEEN EXISTS IN IS LIKE NOT OR SOME | ~ [KEYWORDS5:GLOBAL] # Built-In Functions ABS ACOS APP_NAME ASCII ASIN ATAN ATN2 AVG BINARY_CHECKSUM CASE CAST CEILING CHARINDEX CHECKSUM CHECKSUM_AGG COALESCE COL_LENGTH COL_NAME COLLATIONPROPERTY COLUMNPROPERTY CONTAINSTABLE CONVERT COS COT COUNT COUNT_BIG CURRENT_TIMESTAMP CURRENT_USER CURSOR_STATUS DATABASEPROPERTY DATABASEPROPERTYEX DATALENGTH DATEADD DATEDIFF DATENAME DATEPART DAY DB_ID DB_NAME DEGREES DIFFERENCE EXP FILE_ID FILE_NAME FILEGROUP_ID FILEGROUP_NAME FILEGROUPPROPERTY FILEPROPERTY FLOOR FORMATMESSAGE FREETEXTTABLE FULLTEXTCATALOGPROPERTY FULLTEXTSERVICEPROPERTY GETANSINULL GETDATE GETUTCDATE GROUPING HAS_DBACCESS HOST_ID HOST_NAME IDENT_CURRENT IDENT_INCR IDENT_SEED IDENTITY INDEX_COL INDEXKEY_PROPERTY INDEXPROPERTY IS_MEMBER IS_SRVROLEMEMBER ISDATE ISNULL ISNUMERIC LEFT LEN LOG LOG10 LOWER LTRIM MAX MIN MONTH NEWID NULLIF OBJECT_ID OBJECT_NAME OBJECTPROPERTY OPENDATASOURCE OPENQUERY OPENROWSET OPENXML PARSENAME PATINDEX PERMISSIONS PI POWER QUOTENAME RADIANS RAND REPLACE REPLICATE REVERSE RIGHT ROUND ROWCOUNT_BIG RTRIM SCOPE_IDENTITY SERVERPROPERTY SESSION_USER SESSIONPROPERTY SIGN SIN SOUNDEX SPACE SQL_VARIANT_PROPERTY SQRT SQUARE STATS_DATE STDEV STDEVP STR STUFF SUBSTRING SUM SUSER_SID SUSER_SNAME SYSTEM_USER TAN TEXTPTR TEXTVALID TYPEPROPERTY UNICODE UPPER USER USER_ID USER_NAME VAR VARP YEAR [KEYWORDS6:GLOBAL] # System Tables & Views backupfile backupmediafamily backupmediaset backupset CHECK_CONSTRAINTS COLUMN_DOMAIN_USAGE COLUMN_PRIVILEGES COLUMNS CONSTRAINT_COLUMN_USAGE CONSTRAINT_TABLE_USAGE DOMAIN_CONSTRAINTS DOMAINS KEY_COLUMN_USAGE log_shipping_databases log_shipping_monitor log_shipping_plan_databases log_shipping_plan_history log_shipping_plans log_shipping_primaries log_shipping_secondaries logmarkhistory MSreplication_options mswebtasks PARAMETERS REFERENTIAL_CONSTRAINTS restorefile restorefilegroup restorehistory ROUTINE_COLUMNS ROUTINES RTblClassDefs RTblDatabaseVersion RTblDBMProps RTblDBXProps RTblDTMProps RTblDTSProps RTblEnumerationDef RTblEnumerationValueDef RTblEQMProps RTblGENProps RTblIfaceDefs RTblIfaceHier RTblIfaceMem RTblMDSProps RTblNamedObj RTblOLPProps RTblParameterDef RTblPropDefs RTblProps RTblRelColDefs RTblRelshipDefs RTblRelshipProps RTblRelships RTblScriptDefs RTblSIMProps RTblSites RTblSumInfo RTblTFMProps RTblTypeInfo RTblTypeLibs RTblUMLProps RTblUMXProps RTblVersionAdminInfo RTblVersions RTblWorkspaceItems SCHEMATA spt_datatype_info spt_datatype_info_ext spt_fallback_db spt_fallback_dev spt_fallback_usg spt_monitor spt_provider_types spt_server_info spt_values sqlagent_info sysalerts sysaltfiles syscachedcredentials syscacheobjects syscategories syscharsets syscolumns syscomments sysconfigures sysconstraints syscurconfigs syscursorcolumns syscursorrefs syscursors syscursortables sysdatabases sysdbmaintplan_databases sysdbmaintplan_history sysdbmaintplan_jobs sysdbmaintplans sysdepends sysdevices sysdownloadlist sysdtscategories sysdtspackagelog sysdtspackages sysdtssteplog sysdtstasklog sysfilegroups sysfiles sysfiles1 sysforeignkeys sysfulltextcatalogs sysfulltextnotify sysindexes sysindexkeys sysjobhistory sysjobs sysjobs_view sysjobschedules sysjobservers sysjobsteps syslanguages syslockinfo syslocks syslogins sysmembers sysmessages sysnotifications sysobjects sysoledbusers sysopentapes sysoperators sysperfinfo syspermissions sysprocesses sysproperties sysprotects sysreferences SYSREMOTE_CATALOGS SYSREMOTE_COLUMN_PRIVILEGES SYSREMOTE_COLUMNS SYSREMOTE_FOREIGN_KEYS SYSREMOTE_INDEXES SYSREMOTE_PRIMARY_KEYS SYSREMOTE_PROVIDER_TYPES SYSREMOTE_SCHEMATA SYSREMOTE_STATISTICS SYSREMOTE_TABLE_PRIVILEGES SYSREMOTE_TABLES SYSREMOTE_VIEWS sysremotelogins syssegments sysservers systargetservergroupmembers systargetservergroups systargetservers systargetservers_view systaskids systasks systasks_view systypes sysusers sysxlogins TABLE_CONSTRAINTS TABLE_PRIVILEGES TABLES VIEW_COLUMN_USAGE VIEW_TABLE_USAGE VIEWS [KEYWORDS7:GLOBAL] # System Stored Procedures, Extended Stored Procedure and Functions fn_chariswhitespace fn_dblog fn_escapecmdshellsymbols fn_escapecmdshellsymbolsremovequotes fn_generateparameterpattern fn_get_sql fn_getpersistedservernamecasevariation fn_helpcollations fn_isreplmergeagent fn_listextendedproperty fn_MSFullText fn_MSgensqescstr fn_MSsharedversion fn_removeparameterwithargument fn_repladjustcolumnmap fn_replbitstringtoint fn_replcomposepublicationsnapshotfolder fn_replgenerateshorterfilenameprefix fn_replgetagentcommandlinefromjobid fn_replgetbinary8lodword fn_replinttobitstring fn_replmakestringliteral fn_replprepadbinary8 fn_replquotename fn_replrotr fn_repltrimleadingzerosinhexstr fn_repluniquename fn_serverid fn_servershareddrives fn_skipparameterargument fn_sqlvarbasetostr fn_trace_geteventinfo fn_trace_getfilterinfo fn_trace_getinfo fn_trace_gettable fn_updateparameterwithargument fn_varbintohexstr fn_varbintohexsubstring fn_virtualfilestats fn_virtualservernodes MS_sqlctrs_users r_iRTblClassDefs r_iRTblDBMProps r_iRTblDBXProps r_iRTblDTMProps r_iRTblDTSProps r_iRTblEnumerationDef r_iRTblEnumerationValueDef r_iRTblEQMProps r_iRTblGENProps r_iRTblIfaceDefs r_iRTblIfaceMem r_iRTblMDSProps r_iRTblNamedObj r_iRTblOLPProps r_iRTblParameterDef r_iRTblPropDefs r_iRTblProps r_iRTblRelColDefs r_iRTblRelshipDefs r_iRTblRelshipProps r_iRTblRelships r_iRTblScriptDefs r_iRTblSIMProps r_iRTblSites r_iRTblSumInfo r_iRTblTFMProps r_iRTblTypeInfo r_iRTblTypeLibs r_iRTblUMLProps r_iRTblUMXProps r_iRTblVersionAdminInfo r_iRTblVersions r_iRTblWorkspaceItems sp_ActiveDirectory_Obj sp_ActiveDirectory_SCP sp_ActiveDirectory_Start sp_add_agent_parameter sp_add_agent_profile sp_add_alert sp_add_category sp_add_data_file_recover_suspect_db sp_add_datatype_mapping sp_add_dtscategory sp_add_dtspackage sp_add_file_recover_suspect_db sp_add_job sp_add_jobschedule sp_add_jobserver sp_add_jobstep sp_add_jobstep_internal sp_add_log_file_recover_suspect_db sp_add_log_shipping_database sp_add_log_shipping_monitor_jobs sp_add_log_shipping_plan sp_add_log_shipping_plan_database sp_add_log_shipping_primary sp_add_log_shipping_secondary sp_add_maintenance_plan sp_add_maintenance_plan_db sp_add_maintenance_plan_job sp_add_notification sp_add_operator sp_add_server_sortinfo sp_add_server_sortinfo75 sp_add_targetservergroup sp_add_targetsvrgrp_member sp_addalias sp_addapprole sp_addarticle sp_adddistpublisher sp_adddistributiondb sp_adddistributor sp_addextendedproc sp_addextendedproperty sp_addgroup sp_addlinkedserver sp_addlinkedsrvlogin sp_addlogin sp_addmergealternatepublisher sp_addmergearticle sp_addmergefilter sp_addmergepublication sp_addmergepullsubscription sp_addmergepullsubscription_agent sp_addmergesubscription sp_addmessage sp_addpublication sp_addpublication_snapshot sp_addpublisher sp_addpullsubscription sp_addpullsubscription_agent sp_addqueued_artinfo sp_addremotelogin sp_addrole sp_addrolemember sp_addscriptexec sp_addserver sp_addsrvrolemember sp_addsubscriber sp_addsubscriber_schedule sp_addsubscription sp_addsynctriggers sp_addtabletocontents sp_addtask sp_addtype sp_addumpdevice sp_adduser sp_adjustpublisheridentityrange sp_altermessage sp_apply_job_to_targets sp_approlepassword sp_article_validation sp_articlecolumn sp_articlefilter sp_articlesynctranprocs sp_articleview sp_attach_db sp_attach_single_file_db sp_attachsubscription sp_autostats sp_bcp_dbcmptlevel sp_bindefault sp_bindrule sp_bindsession sp_blockcnt sp_browsemergesnapshotfolder sp_browsesnapshotfolder sp_can_tlog_be_applied sp_catalogs sp_catalogs_rowset sp_certify_removable sp_change_agent_parameter sp_change_agent_profile sp_change_monitor_role sp_change_primary_role sp_change_secondary_role sp_change_subscription_properties sp_change_users_login sp_changearticle sp_changedbowner sp_changedistpublisher sp_changedistributiondb sp_changedistributor_password sp_changedistributor_property sp_changegroup sp_changemergearticle sp_changemergefilter sp_changemergepublication sp_changemergepullsubscription sp_changemergesubscription sp_changeobjectowner sp_changepublication sp_changesubscriber sp_changesubscriber_schedule sp_changesubscription sp_changesubscriptiondtsinfo sp_changesubstatus sp_check_constbytable_rowset sp_check_constraints_rowset sp_check_for_owned_jobs sp_check_for_owned_jobsteps sp_check_for_sync_trigger sp_check_publication_access sp_check_removable sp_check_removable_sysusers sp_check_sync_trigger sp_checknames sp_cleanupdbreplication sp_cleanupwebtask sp_clear_dbmaintplan_by_db sp_column_privileges sp_column_privileges_ex sp_column_privileges_rowset sp_columns sp_columns_ex sp_columns_rowset sp_configure sp_convert_jobid_to_char sp_convertwebtasks sp_copymergesnapshot sp_copysnapshot sp_copysubscription sp_create_log_shipping_monitor_account sp_create_removable sp_createmergepalrole sp_createorphan sp_createstats sp_cursor sp_cursor_list sp_cursorclose sp_cursorexecute sp_cursorfetch sp_cursoropen sp_cursoroption sp_cursorprepare sp_cursorprepexec sp_cursorunprepare sp_cycle_errorlog sp_databases sp_datatype_info sp_db_upgrade sp_dbcmptlevel sp_dbfixedrolepermission sp_dboption sp_dbremove sp_ddopen sp_defaultdb sp_defaultlanguage sp_define_log_shipping_monitor sp_delete_alert sp_delete_all_msx_jobs sp_delete_backup_and_restore_history sp_delete_backuphistory sp_delete_category sp_delete_database_backuphistory sp_delete_job sp_delete_job_references sp_delete_jobschedule sp_delete_jobserver sp_delete_jobstep sp_delete_log_shipping_database sp_delete_log_shipping_monitor_info sp_delete_log_shipping_monitor_jobs sp_delete_log_shipping_plan sp_delete_log_shipping_plan_database sp_delete_log_shipping_primary sp_delete_log_shipping_secondary sp_delete_maintenance_plan sp_delete_maintenance_plan_db sp_delete_maintenance_plan_job sp_delete_notification sp_delete_operator sp_delete_targetserver sp_delete_targetservergroup sp_delete_targetsvrgrp_member sp_deletemergeconflictrow sp_denylogin sp_depends sp_describe_cursor sp_describe_cursor_columns sp_describe_cursor_tables sp_detach_db sp_disableagentoffload sp_diskdefault sp_distcounters sp_downloaded_row_limiter sp_drop_agent_parameter sp_drop_agent_profile sp_drop_dtscategory sp_drop_dtspackage sp_dropalias sp_dropanonymousagent sp_dropapprole sp_droparticle sp_dropdevice sp_dropdistpublisher sp_dropdistributiondb sp_dropdistributor sp_dropextendedproc sp_dropextendedproperty sp_dropgroup sp_droplinkedsrvlogin sp_droplogin sp_dropmergealternatepublisher sp_dropmergearticle sp_dropmergefilter sp_dropmergepublication sp_dropmergepullsubscription sp_dropmergesubscription sp_dropmessage sp_droporphans sp_droppublication sp_droppublisher sp_droppullsubscription sp_dropremotelogin sp_droprole sp_droprolemember sp_dropserver sp_dropsrvrolemember sp_dropsubscriber sp_dropsubscription sp_droptask sp_droptype sp_dropuser sp_dropwebtask sp_dsninfo sp_dump_dtslog_all sp_dump_dtspackagelog sp_dump_dtssteplog sp_dump_dtstasklog sp_enableagentoffload sp_enlist_tsx sp_enum_dtscategories sp_enum_dtspackagelog sp_enum_dtspackages sp_enum_dtssteplog sp_enum_dtstasklog sp_enum_oledb_providers sp_enum_sqlagent_subsystems sp_enumcodepages sp_enumcustomresolvers sp_enumdsn sp_enumerrorlogs sp_enumfullsubscribers sp_enumoledbdatasources sp_eventlog sp_execresultset sp_execute sp_executesql sp_expired_subscription_cleanup sp_fallback_MS_sel_fb_svr sp_fetchshowcmdsinput sp_fixindex sp_fkeys sp_foreign_keys_rowset sp_foreignkeys sp_fulltext_catalog sp_fulltext_column sp_fulltext_database sp_fulltext_getdata sp_fulltext_service sp_fulltext_table sp_generate_agent_parameter sp_generate_server_description sp_generate_target_server_job_assignment_sql sp_generatefilters sp_get_chunked_jobstep_params sp_get_composite_job_info sp_get_distributor sp_get_dtspackage sp_get_dtsversion sp_get_job_alerts sp_get_jobstep_db_username sp_get_log_shipping_monitor_info sp_get_message_description sp_get_schedule_description sp_get_sqlagent_properties sp_getagentoffloadinfo sp_getapplock sp_getarticlepkcolbitmap sp_getbindtoken sp_GetMBCSCharLen sp_getmergedeletetype sp_getqueuedarticlesynctraninfo sp_getqueuedrows sp_getschemalock sp_getsqlqueueversion sp_getsubscriptiondtspackagename sp_gettypestring sp_grant_publication_access sp_grantdbaccess sp_grantlogin sp_help sp_help_agent_default sp_help_agent_parameter sp_help_agent_profile sp_help_alert sp_help_category sp_help_datatype_mapping sp_help_downloadlist sp_help_fulltext_catalogs sp_help_fulltext_catalogs_cursor sp_help_fulltext_columns sp_help_fulltext_columns_cursor sp_help_fulltext_tables sp_help_fulltext_tables_cursor sp_help_job sp_help_jobhistory sp_help_jobschedule sp_help_jobserver sp_help_jobstep sp_help_maintenance_plan sp_help_notification sp_help_operator sp_help_operator_jobs sp_help_publication_access sp_help_targetserver sp_help_targetservergroup sp_helpallowmerge_publication sp_helparticle sp_helparticlecolumns sp_helparticledts sp_helpconstraint sp_helpdb sp_helpdbfixedrole sp_helpdevice sp_helpdistpublisher sp_helpdistributiondb sp_helpdistributor sp_helpdistributor_properties sp_helpextendedproc sp_helpfile sp_helpfilegroup sp_helpgroup sp_helphistory sp_helpindex sp_helplanguage sp_helplinkedsrvlogin sp_helplog sp_helplogins sp_helpmergealternatepublisher sp_helpmergearticle sp_helpmergearticlecolumn sp_helpmergearticleconflicts sp_helpmergecleanupwait sp_helpmergeconflictrows sp_helpmergedeleteconflictrows sp_helpmergefilter sp_helpmergepublication sp_helpmergepullsubscription sp_helpmergesubscription sp_helpntgroup sp_helppublication sp_helppublicationsync sp_helppullsubscription sp_helpremotelogin sp_helpreplfailovermode sp_helpreplicationdb sp_helpreplicationdboption sp_helpreplicationoption sp_helprole sp_helprolemember sp_helprotect sp_helpserver sp_helpsort sp_helpsql sp_helpsrvrole sp_helpsrvrolemember sp_helpstats sp_helpsubscriberinfo sp_helpsubscription sp_helpsubscription_properties sp_helptask sp_helptext sp_helptrigger sp_helpuser sp_indexes sp_indexes_rowset sp_indexoption sp_insmswebtask sp_invalidate_textptr sp_is_sqlagent_starting sp_isarticlecolbitset sp_IsMBCSLeadByte sp_ivindexhasnullcols sp_jobhistory_row_limiter sp_link_publication sp_linkedservers sp_linkedservers_rowset sp_lock sp_log_dtspackage_begin sp_log_dtspackage_end sp_log_dtsstep_begin sp_log_dtsstep_end sp_log_dtstask sp_log_shipping_get_date_from_file sp_log_shipping_in_sync sp_log_shipping_monitor_backup sp_log_shipping_monitor_restore sp_logdevice sp_make_dtspackagename sp_makewebtask sp_manage_jobs_by_login sp_marksubscriptionvalidation sp_mergearticlecolumn sp_mergecleanupmetadata sp_mergecompletecleanup sp_mergedummyupdate sp_mergemetadataretentioncleanup sp_mergepreparecleanup sp_mergesubscription_cleanup sp_modify_dtscategory sp_monitor sp_MS_marksystemobject sp_MS_replication_installed sp_MS_upd_sysobj_category sp_MSacquireHeadofQueueLock sp_MSacquireserverresourcefordynamicsnapshot sp_MSacquireSlotLock sp_MSactivate_auto_sub sp_MSadd_compensating_cmd sp_MSadd_distributor_alerts_and_responses sp_MSadd_mergereplcommand sp_MSadd_repl_job sp_MSaddanonymousreplica sp_MSaddexecarticle sp_MSaddguidcolumn sp_MSaddguidindex sp_MSaddinitialarticle sp_MSaddinitialpublication sp_MSaddinitialschemaarticle sp_MSaddinitialsubscription sp_MSaddlogin_implicit_ntlogin sp_MSaddmergedynamicsnapshotjob sp_MSaddmergepub_snapshot sp_MSaddmergeschemaarticle sp_MSaddmergetriggers sp_MSaddoffloadparameter sp_MSaddpub_snapshot sp_MSaddpubtocontents sp_MSaddschemaarticle sp_MSaddupdatetrigger sp_MSadduser_implicit_ntlogin sp_MSadjustmergeidentity sp_MSagent_access_check sp_MSalreadyhavegeneration sp_MSareallcolumnscomputed sp_MSarticlecleanup sp_MSarticlecol sp_MSarticlecolstatus sp_MSbelongs sp_MSBumpupCompLevel sp_MSchange_priority sp_MSchange_retention sp_MSchangearticleresolver sp_MSchangemergeschemaarticle sp_MSchangeobjectowner sp_MSchangeschemaarticle sp_MScheck_agent_instance sp_MScheck_subscription sp_MScheck_uid_owns_anything sp_MScheckatpublisher sp_MScheckexistsgeneration sp_MScheckidentityrange sp_MSCheckmergereplication sp_MScheckmetadatamatch sp_MSchecksnapshotstatus sp_MScheckvalidsystables sp_MSchunkgeneration sp_MScleanup_conflict sp_MScleanup_conflict_table sp_MScleanup_metadata sp_MScleanup_publication_ADinfo sp_MScleanup_zeroartnick_genhistory sp_MScleanupdynsnapshotvws sp_MSCleanupForPullReinit sp_MScleanupmergepublisher sp_MScleanupmergepublisherdb sp_MScleanuptask sp_MSclearcolumnbit sp_MScompletecleanup sp_MScomputearticlescreationorder sp_MScomputemergearticlescreationorder sp_MScomputemergeunresolvedrefs sp_MScomputeunresolvedrefs sp_MScontractsubsnb sp_MScopyregvalue sp_MScopyscriptfile sp_MScopysnapshot sp_MScreate_dist_tables sp_MScreate_distributor_tables sp_MScreate_mergesystables sp_MScreate_pub_tables sp_MScreate_replication_checkup_agent sp_MScreate_replication_status_table sp_MScreate_sub_tables sp_MScreatebeforetable sp_MScreatedupkeyupdatequery sp_MScreateglobalreplica sp_MScreateretry sp_MSdbuseraccess sp_MSdbuserpriv sp_MSdefer_check sp_MSdelete_specifiedcontents sp_MSdeletecontents sp_MSdeletepushagent sp_MSdeleteretry sp_MSdeletetranconflictrow sp_MSdelgenzero sp_MSdelrow sp_MSdelsubrows sp_MSdelsubrowsbatch sp_MSdependencies sp_MSdoesfilterhaveparent sp_MSdrop_6x_replication_agent sp_MSdrop_distributor_alerts_and_responses sp_MSdrop_expired_mergesubscription sp_MSdrop_expired_subscription sp_MSdrop_mergesystables sp_MSdrop_object sp_MSdrop_pub_tables sp_MSdrop_replcom sp_MSdrop_repltran sp_MSdrop_rladmin sp_MSdrop_rlcore sp_MSdrop_rlrecon sp_MSdroparticleconstraints sp_MSdroparticleprocs sp_MSdroparticletombstones sp_MSdroparticletriggers sp_MSdropconstraints sp_MSdropdynsnapshotvws sp_MSdropfkreferencingarticle sp_MSdropmergedynamicsnapshotjob sp_MSdropmergepub_snapshot sp_MSdropretry sp_MSdroptemptable sp_MSdummyupdate sp_MSenum3rdpartypublications sp_MSenum_misc_agents sp_MSenum_replication_agents sp_MSenum_replication_job sp_MSenum_replqueues sp_MSenum_replsqlqueues sp_MSenumallpublications sp_MSenumallsubscriptions sp_MSenumchanges sp_MSenumchanges_direct sp_MSenumchanges_pal sp_MSenumcolumns sp_MSenumdeletesmetadata sp_MSenumgenerations sp_MSenummergepublications sp_MSenumpartialchanges sp_MSenumpartialchanges_direct sp_MSenumpartialchanges_pal sp_MSenumpartialdeletes sp_MSenumpubreferences sp_MSenumreplicas sp_MSenumretries sp_MSenumschemachange sp_MSenumschemachange_70 sp_MSenumschemachange_80 sp_MSenumschemachange_80sp3 sp_MSenumsubscriptions sp_MSenumthirdpartypublicationvendornames sp_MSenumtranpublications sp_MSestimatemergesnapshotworkload sp_MSestimatesnapshotworkload sp_MSevalsubscriberinfo sp_MSexclause sp_MSexpandbelongs sp_MSexpandnotbelongs sp_MSexpandsubsnb sp_MSexternalfkreferences sp_MSfetchidentityrange sp_MSfillupmissingcols sp_MSfilterclause sp_MSfix_6x_tasks sp_MSfixlineageversions sp_MSfixupagentoffloadinfo sp_MSfixupaltsnapshotfolder sp_MSfixupbeforeimagetables sp_MSfixupdistributorinfo sp_MSfixupdistributorsecurity sp_MSfixupftpinfo sp_MSfixupsharedagentproperties sp_MSfixupuseftp sp_MSfixupworkingdirectory sp_MSflush_access_cache sp_MSflush_command sp_MSforeach_worker sp_MSforeachdb sp_MSforeachtable sp_MSgen_sync_tran_procs sp_MSgenreplnickname sp_MSgentablenickname sp_MSget_agent_names sp_MSget_attach_state sp_MSget_col_position sp_MSget_colinfo sp_MSget_current_activity sp_MSget_file_existence sp_MSget_jobstate sp_MSget_load_hint sp_MSget_map_position sp_MSget_mergepullsubsagent_owner sp_MSget_oledbinfo sp_MSget_publication_from_taskname sp_MSget_publisher_rpc sp_MSget_pullsubsagent_owner sp_MSget_qualified_name sp_MSget_setup_paths sp_MSget_shared_agent sp_MSget_subtypedatasrc sp_MSget_synctran_column sp_MSget_synctran_commands sp_MSget_type sp_MSgetalertinfo sp_MSgetarticlereinitvalue sp_MSgetbeforetableinsert sp_MSgetchangecount sp_MSgetcolordinalfromcolname sp_MSgetcolumnlist sp_MSgetconflictinsertproc sp_MSgetconflicttablename sp_MSgetlastrecgen sp_MSgetlastsentgen sp_MSgetlastsentrecgens sp_MSgetlastupdatedtime sp_MSgetmakegenerationapplock sp_MSgetmergelastupdatedtime sp_MSgetmetadatabatch sp_MSgetonerow sp_MSgetpubinfo sp_MSgetreplicainfo sp_MSgetreplnick sp_MSgetrowmetadata sp_MSGetServerProperties sp_MSgetsubscriberinfo sp_MSgettablecontents sp_MSgettools_path sp_MSgettrancftsrcrow sp_MSgettranconflictname sp_MSgettranconflictrow sp_MSgettranlastupdatedtime sp_MSgettypestringudt sp_MSgetversion sp_MSgetviewcolumnlist sp_MSguidtostr sp_MShasdbaccess sp_MShelp_distdb sp_MShelp_identity_property sp_MShelp_replication_status sp_MShelp_replication_table sp_MShelpalterbeforetable sp_MShelpcolumns sp_MShelpconflictpublications sp_MShelpcreatebeforetable sp_MShelpdestowner sp_MShelpfulltextindex sp_MShelpfulltextscript sp_MShelpindex sp_MShelpmergearticles sp_MShelpmergeconflictcounts sp_MShelpmergeconflictpublications sp_MShelpmergedynamicsnapshotjob sp_MShelpmergeidentity sp_MShelpmergeschemaarticles sp_MShelpobjectpublications sp_MShelptranconflictcounts sp_MShelptranconflictpublications sp_MShelptype sp_MShelpvalidationdate sp_MSIfExistsRemoteLogin sp_MSindexcolfrombin sp_MSindexspace sp_MSinit_replication_perfmon sp_MSinit_subscription_agent sp_MSinitdynamicsubscriber sp_MSinsertbeforeimageclause sp_MSinsertcontents sp_MSinsertdeleteconflict sp_MSinserterrorlineage sp_MSinsertgenerationschemachanges sp_MSinsertgenhistory sp_MSinsertschemachange sp_MSinstance_qv sp_MSis_col_replicated sp_MSis_identity_insert sp_MSis_pk_col sp_MSisnonpkukupdateinconflict sp_MSispkupdateinconflict sp_MSispulldistributionjobnamegenerated sp_MSispullmergejobnamegenerated sp_MSkilldb sp_MSload_replication_status sp_MSlocalizeinterruptedgenerations sp_MSlocktable sp_MSloginmappings sp_MSmakearticleprocs sp_MSmakeconflictinsertproc sp_MSmakeconflicttable sp_MSmakectsview sp_MSmakedynsnapshotvws sp_MSmakeexpandproc sp_MSmakegeneration sp_MSmakeinsertproc sp_MSmakejoinfilter sp_MSmakeselectproc sp_MSmakesystableviews sp_MSmaketempinsertproc sp_MSmaketrancftproc sp_MSmakeupdateproc sp_MSmakeviewproc sp_MSmaptype sp_MSmark_proc_norepl sp_MSmarkreplinfo sp_MSmarkschemaobject sp_MSmatchkey sp_MSmergepublishdb sp_MSmergesubscribedb sp_MSmergeupdatelastsyncinfo sp_MSobjectprivs sp_MSobjsearch sp_MSpad_command sp_MSpost_auto_proc sp_MSprep_exclusive sp_MSprepare_mergearticle sp_MSprepare_sub_for_detach sp_MSpreparecleanup sp_MSpropagateschematorepubs sp_MSproxiedmetadata sp_MSpub_adjust_identity sp_MSpublicationcleanup sp_MSpublicationview sp_MSpublishdb sp_MSpurgecontentsorphans sp_MSquerysubtype sp_MSquiescecheck sp_MSquiesceforcleanup sp_MSquiescetriggersoff sp_MSquiescetriggerson sp_MSreenable_check sp_MSrefcnt sp_MSregistersubscription sp_MSreinit_article sp_MSreinit_failed_subscriptions sp_MSreinit_hub sp_MSreinitmergepublication sp_MSreleasemakegenerationapplock sp_MSreleaseSlotLock sp_MSremove_mergereplcommand sp_MSremove_userscript sp_MSremovedbreplication sp_MSremoveoffloadparameter sp_MSrepl_addrolemember sp_MSrepl_backup_complete sp_MSrepl_backup_start sp_MSrepl_check_server sp_MSrepl_dbrole sp_MSrepl_droprolemember sp_MSrepl_FixPALRole sp_MSrepl_gettype_mappings sp_MSrepl_isdbowner sp_MSrepl_linkedservers_rowset sp_MSrepl_PAL_rolecheck sp_MSrepl_schema sp_MSrepl_startup sp_MSrepl_validate_dts_package sp_MSreplcheck_connection sp_MSreplcheck_name sp_MSreplcheck_permission sp_MSreplcheck_publish sp_MSreplcheck_pull sp_MSreplcheck_qv sp_MSreplcheck_subscribe sp_MSreplcheckoffloadserver sp_MSreplicationcompatlevel sp_MSreplraiserror sp_MSreplrole sp_MSreplsup_table_has_pk sp_MSreplupdateschema sp_MSreseed sp_MSreset_attach_state sp_MSreset_queue sp_MSreset_queued_reinit sp_MSreset_synctran_bit sp_MSrestore_sub sp_MSrestore_sub_merge sp_MSrestore_sub_tran sp_MSretrieve_mergepublication sp_MSretrieve_publication sp_MSretrieve_publication_attributes sp_MSscript_article_view sp_MSscript_beginproc sp_MSscript_begintrig1 sp_MSscript_begintrig2 sp_MSscript_compensating_insert sp_MSscript_compensating_send sp_MSscript_delete_pubwins sp_MSscript_delete_statement sp_MSscript_delete_subwins sp_MSscript_dri sp_MSscript_endproc sp_MSscript_endtrig sp_MSscript_ExecutionMode_stmt sp_MSscript_insert_pubwins sp_MSscript_insert_statement sp_MSscript_insert_subwins sp_MSscript_missing_row_check sp_MSscript_multirow_trigger sp_MSscript_params sp_MSscript_pkvar_assignment sp_MSscript_procbodystart sp_MSscript_pub_upd_trig sp_MSscript_security sp_MSscript_singlerow_trigger sp_MSscript_sync_del_proc sp_MSscript_sync_del_trig sp_MSscript_sync_ins_proc sp_MSscript_sync_ins_trig sp_MSscript_sync_upd_proc sp_MSscript_sync_upd_trig sp_MSscript_trigger_assignment sp_MSscript_trigger_exec_rpc sp_MSscript_trigger_fetch_statement sp_MSscript_trigger_update_checks sp_MSscript_trigger_updates sp_MSscript_trigger_variables sp_MSscript_trigger_version_updates sp_MSscript_update_pubwins sp_MSscript_update_statement sp_MSscript_update_subwins sp_MSscript_validate_subscription sp_MSscript_where_clause sp_MSscriptdatabase sp_MSscriptdb_worker sp_MSscriptdelconflictfinder sp_MSscriptinsertconflictfinder sp_MSscriptmvastable sp_MSscriptmvastableidx sp_MSscriptmvastablenci sp_MSscriptmvastablepkc sp_MSscriptupdateconflictfinder sp_MSscriptviewproc sp_MSsendtosqlqueue sp_MSset_current_activity sp_MSset_sub_guid sp_MSset_subscription_properties sp_MSsetaccesslist sp_MSsetalertinfo sp_MSsetartprocs sp_MSsetbit sp_MSsetconflictscript sp_MSsetconflicttable sp_MSsetcontext_replagent sp_MSsetfilteredstatus sp_MSsetfilterparent sp_MSsethighestversion sp_MSsetlastrecgen sp_MSsetlastsentgen sp_MSsetreplicainfo sp_MSsetreplicastatus sp_MSsetrowmetadata sp_MSSetServerProperties sp_MSsetsubscriberinfo sp_MSsettopology sp_MSsetupbelongs sp_MSsetupbelongs_withoutviewproc sp_MSsetupnotbelongs sp_MSsetupworktables sp_MSSharedFixedDisk sp_MSSQLDMO70_version sp_MSSQLDMO80_version sp_MSSQLOLE65_version sp_MSSQLOLE_version sp_MSsub_check_identity sp_MSsub_cleanup_orphans sp_MSsub_cleanup_prop_table sp_MSsub_set_identity sp_MSsubscription_enabled_for_syncmgr sp_MSsubscriptionvalidated sp_MSsubsetpublication sp_MSsubst_filter_name sp_MSsubst_filter_names sp_MStable_has_unique_index sp_MStable_not_modifiable sp_MStablechecks sp_MStablekeys sp_MStablenamefromnick sp_MStablenickname sp_MStablerefs sp_MStablespace sp_MStestbit sp_MSunc_to_drive sp_MSuniquecolname sp_MSuniquename sp_MSuniqueobjectname sp_MSuniquetempname sp_MSunmarkifneeded sp_MSunmarkreplinfo sp_MSunmarkschemaobject sp_MSunregistersubscription sp_MSupdate_agenttype_default sp_MSupdate_mqserver_distdb sp_MSupdate_mqserver_subdb sp_MSupdate_replication_status sp_MSupdatecontents sp_MSupdategenhistory sp_MSupdatelastsyncinfo sp_MSupdateschemachange sp_MSupdatesharedagentproperties sp_MSupdatesysmergearticles sp_msupg_createcatalogcomputedcols sp_msupg_dosystabcatalogupgrades sp_msupg_dropcatalogcomputedcols sp_msupg_recreatecatalogfaketables sp_msupg_recreatesystemviews sp_msupg_removesystemcomputedcolumns sp_msupg_upgradecatalog sp_MSUpgradeConflictTable sp_MSuplineageversion sp_MSvalidate_agent_parameter sp_MSvalidate_subscription sp_MSvalidatearticle sp_MSverifytranfilter sp_msx_defect sp_msx_enlist sp_multi_server_job_summary sp_OACreate sp_OADestroy sp_OAGetErrorInfo sp_OAGetProperty sp_OAMethod sp_OASetProperty sp_OAStop sp_objectfilegroup sp_oledb_column_constraints sp_oledb_database sp_oledb_defdb sp_oledb_deflang sp_oledb_indexinfo sp_oledb_language sp_oledb_ro_usrname sp_oledbinfo sp_password sp_pkeys sp_populateqtraninfo sp_post_msx_operation sp_prepare sp_prepexec sp_prepexecrpc sp_primary_keys_rowset sp_primarykeys sp_procedure_params_rowset sp_procedures_rowset sp_processmail sp_procoption sp_prop_oledb_provider sp_provider_types_rowset sp_publication_validation sp_publishdb sp_purge_jobhistory sp_purgehistory sp_readerrorlog sp_readwebtask sp_reassign_dtspackagecategory sp_reassign_dtspackageowner sp_reassigntask sp_recompile sp_refreshsubscriptions sp_refreshview sp_reinitmergepullsubscription sp_reinitmergesubscription sp_reinitpullsubscription sp_reinitsubscription sp_releaseapplock sp_releaseschemalock sp_remoteoption sp_remove_job_from_targets sp_remove_log_shipping_monitor sp_remove_log_shipping_monitor_account sp_remove_tempdb_file sp_removedbreplication sp_removesrvreplication sp_rename sp_renamedb sp_repladdcolumn sp_replcmds sp_replcounters sp_repldeletequeuedtran sp_repldone sp_repldropcolumn sp_replflush sp_replica sp_replication_agent_checkup sp_replicationdboption sp_replicationoption sp_replincrementlsn sp_replincrementlsn_internal sp_replpostcmd sp_replpostschema sp_replpostsyncstatus sp_replpostsyncstatus_int sp_replproberemoteserver sp_replqueuemonitor sp_replrestart sp_replscriptuniquekeywhereclause sp_replsendtoqueue sp_replsetoriginator sp_replsetoriginator_internal sp_replsetoriginator_pal sp_replsetsyncstatus sp_replshowcmds sp_replsqlqgetrows sp_replsync sp_repltablehasnonpkuniquekey sp_repltrans sp_replupdateschema sp_replwritetovarbin sp_reset_connection sp_resetstatus sp_resolve_logins sp_restoredbreplication sp_resync_targetserver sp_resyncexecute sp_resyncexecutesql sp_resyncmergesubscription sp_resyncprepare sp_resyncuniquetable sp_revoke_publication_access sp_revokedbaccess sp_revokelogin sp_runwebtask sp_schemata_rowset sp_script_insertforcftresolution sp_script_reconciliation_delproc sp_script_reconciliation_insproc sp_script_reconciliation_xdelproc sp_script_synctran_commands sp_scriptdelproc sp_scriptdynamicupdproc sp_scriptinsproc sp_scriptmappedupdproc sp_scriptpkwhereclause sp_scriptpublicationcustomprocs sp_scriptpubwinsrefreshcursorvars sp_scriptreconwhereclause sp_scriptsubconflicttable sp_scriptupdateparams sp_scriptupdproc sp_scriptxdelproc sp_scriptxupdproc sp_sdidebug sp_sem_add_message sp_sem_drop_message sp_server_info sp_serveroption sp_set_local_time sp_set_sqlagent_properties sp_setapprole sp_setnetname sp_setreplfailovermode sp_settriggerorder sp_setuserbylogin sp_showrowreplicainfo sp_spaceused sp_special_columns sp_sproc_columns sp_sqlagent_check_msx_version sp_sqlagent_get_perf_counters sp_sqlagent_get_startup_info sp_sqlagent_has_server_access sp_sqlagent_log_jobhistory sp_sqlagent_notify sp_sqlagent_probe_msx sp_sqlagent_refresh_job sp_sqlexec sp_srvrolepermission sp_start_job sp_statistics sp_statistics_rowset sp_stop_job sp_stored_procedures sp_subscribe sp_subscription_cleanup sp_table_constraints_rowset sp_table_privileges sp_table_privileges_ex sp_table_privileges_rowset sp_table_statistics_rowset sp_table_validation sp_tablecollations sp_tableoption sp_tables sp_tables_ex sp_tables_info_rowset sp_tables_rowset sp_tableswc sp_target_server_summary sp_tempdbspace sp_trace_create sp_trace_generateevent sp_trace_getdata sp_trace_setevent sp_trace_setfilter sp_trace_setstatus sp_unbindefault sp_unbindrule sp_uniquetaskname sp_unprepare sp_unsubscribe sp_update_alert sp_update_category sp_update_job sp_update_jobschedule sp_update_jobstep sp_update_log_shipping_monitor_info sp_update_log_shipping_plan sp_update_log_shipping_plan_database sp_update_notification sp_update_operator sp_update_replication_job_parameter sp_update_targetservergroup sp_updateextendedproperty sp_updatestats sp_updatetask sp_updmswebtask sp_user_counter1 sp_user_counter10 sp_user_counter2 sp_user_counter3 sp_user_counter4 sp_user_counter5 sp_user_counter6 sp_user_counter7 sp_user_counter8 sp_user_counter9 sp_validatelogins sp_validatemergepublication sp_validatemergepullsubscription sp_validatemergesubscription sp_validatepropertyinputs sp_validlang sp_validname sp_verify_alert sp_verify_category sp_verify_job sp_verify_job_date sp_verify_job_identifiers sp_verify_job_time sp_verify_jobproc_caller sp_verify_jobschedule sp_verify_jobstep sp_verify_lsp_identifiers sp_verify_notification sp_verify_operator sp_verify_performance_condition sp_verify_publication sp_verify_subsystem sp_verifytaskid sp_vupgrade_distdb sp_vupgrade_mergetables sp_vupgrade_MSsubscription_properties sp_vupgrade_publisher sp_vupgrade_publisherdb sp_vupgrade_registry sp_vupgrade_replication sp_vupgrade_replmsdb sp_vupgrade_subpass sp_vupgrade_subscription_databases sp_vupgrade_subscription_tables sp_vupgrade_syscol_status sp_who sp_who2 sp_xml_preparedocument sp_xml_removedocument xp_adsirequest xp_availablemedia xp_cleanupwebtask xp_cmdshell xp_controlqueueservice xp_convertwebtask xp_createprivatequeue xp_decodequeuecmd xp_deletemail xp_deleteprivatequeue xp_dirtree xp_displayparamstmt xp_displayqueuemesgs xp_dropwebtask xp_dsninfo xp_enum_activescriptengines xp_enum_oledb_providers xp_enumcodepages xp_enumdsn xp_enumerrorlogs xp_enumgroups xp_eventlog xp_execresultset xp_fileexist xp_findnextmsg xp_fixeddrives xp_get_mapi_default_profile xp_get_mapi_profiles xp_get_tape_devices xp_GetAdminGroupName xp_getfiledetails xp_getnetname xp_getprotocoldllinfo xp_grantlogin xp_instance_regaddmultistring xp_instance_regdeletekey xp_instance_regdeletevalue xp_instance_regenumkeys xp_instance_regenumvalues xp_instance_regread xp_instance_regremovemultistring xp_instance_regwrite xp_IsNTAdmin xp_logevent xp_loginconfig xp_logininfo xp_makecab xp_makewebtask xp_mapdown_bitmap xp_mergelineages xp_mergexpusage xp_MSADEnabled xp_MSADSIObjReg xp_MSADSIObjRegDB xp_MSADSIReg xp_MSFullText xp_MSLocalSystem xp_MSnt2000 xp_MSplatform xp_msver xp_msx_enlist xp_ntsec_enumdomains xp_oledbinfo xp_ORbitmap xp_peekqueue xp_printstatements xp_prop_oledb_provider xp_proxiedmetadata xp_qv xp_readerrorlog xp_readmail xp_readpkfromqueue xp_readpkfromvarbin xp_readwebtask xp_regaddmultistring xp_regdeletekey xp_regdeletevalue xp_regenumkeys xp_regenumvalues xp_regread xp_regremovemultistring xp_regwrite xp_repl_convert_encrypt xp_repl_encrypt xp_repl_help_connect xp_replproberemsrv xp_resetqueue xp_revokelogin xp_runwebtask xp_sendmail xp_servicecontrol xp_SetSQLSecurity xp_showcolv xp_showlineage xp_sprintf xp_sqlagent_enum_jobs xp_sqlagent_is_starting xp_sqlagent_monitor xp_sqlagent_msx_account xp_sqlagent_notify xp_sqlagent_param xp_sqlagent_proxy_account xp_sqlmaint xp_sscanf xp_startmail xp_stopmail xp_subdirs xp_test_mapi_profile xp_unc_to_drive xp_unpackcab xp_updateFTSSQLAccount xp_userlock xp_varbintohexstr [KEYWORDS8:GLOBAL] # Other Reserved Keywords ADD ALTER AS ASC AUTHORIZATION BACKUP BEGIN BREAK BROWSE BULK BY CASCADE CHECK CHECKPOINT CLOSE CLUSTERED COLLATE COLUMN COMMIT COMPUTE CONSTRAINT CONTAINS CONTINUE CREATE CROSS CURRENT CURRENT_DATE CURRENT_TIME CURSOR DATABASE DBCC DEALLOCATE DECLARE DEFAULT DELETE DENY DESC DISK DISTINCT DISTRIBUTED DOUBLE DROP DUMMY DUMP ELSE ENCRYPTION END ERRLVL ESCAPE EXCEPT EXEC EXECUTE EXIT FETCH FILE FILLFACTOR FOR FOREIGN FREETEXT FROM FULL FUNCTION GOTO GRANT GROUP HAVING HOLDLOCK IDENTITY_INSERT IDENTITYCOL IF INDEX INNER INSERT INTERSECT INTO JOIN KEY KILL LINENO LOAD MARK NATIONAL NOCHECK NOCOUNT NONCLUSTERED NULL OF OFF OFFSETS ON OPEN OPTION ORDER OUTER OUTPUT OVER OVERRIDE PERCENT PLAN PRECISION PRIMARY PRINT PROC PROCEDURE RAISERROR READ READTEXT RECOMPILE RECONFIGURE REFERENCES REPLICATION RESTORE RESTRICT RETURN REVOKE ROLLBACK ROWCOUNT ROWGUIDCOL RULE SAVE SCHEMA SELECT SET SETUSER SHUTDOWN STANDBY STATISTICS STOPATMARK STOPBEFOREMARK TABLE TEXTSIZE THEN TO TOP TRAN TRANSACTION TRIGGER TRUNCATE TSEQUAL UNION UNIQUE UPDATE UPDATETEXT USE VALUES VARYING VIEW WAITFOR WHEN WHERE WHILE WITH WRITETEXT [KEYWORDS9:GLOBAL] # Unused